FaLoan_Proxy

Logical Entity Name | FaLoan_Proxy
Default Table Name | FaLoan_Proxy
Physical Only | NO
Owner | dbo
Definition |
Note |

FaLoan_Proxy Columns

ColumnName | Domain | Datatype | NULL | Definition
FaLoan_ProxyID |  | int | NO |
RecordID |  | int | YES |
Oldborrowerssn |  | char(16) | YES |
Newborrowerssn |  | char(16) | YES |
Oldborrowerlastname |  | nvarchar(128) | YES |
Newborrowerlastname |  | nvarchar(128) | YES |
Oldborrowerfirstname |  | nvarchar(128) | YES |
Newborrowerfirstname |  | nvarchar(128) | YES |
OldBorrowerAddress |  | varchar(2000) | YES |
NewBorrowerAddress |  | varchar(2000) | YES |
Oldborrowermi |  | char(1) | YES |
Newborrowermi |  | char(1) | YES |
Oldborrowercity |  | char(16) | YES |
Newborrowercity |  | char(16) | YES |
Oldborrowerstate |  | char(2) | YES |
Newborrowerstate |  | char(2) | YES |
Oldborrowerzip |  | char(14) | YES |
Newborrowerzip |  | char(14) | YES |
Oldborrowerphone |  | char(16) | YES |
Newborrowerphone |  | char(16) | YES |
Oldborrowerdriverlicensenumber |  | char(20) | YES |
Newborrowerdriverlicensenumber |  | char(20) | YES |
Oldborrowerdriverlicensestate |  | char(2) | YES |
Newborrowerdriverlicensestate |  | char(2) | YES |
Oldborrowerdob |  | datetime | YES |
Newborrowerdob |  | datetime | YES |
Oldborrowercitizenstatus |  | char(1) | YES |
Newborrowercitizenstatus |  | char(1) | YES |
Oldborrowerdefaultonloans |  | char(1) | YES |
Newborrowerdefaultonloans |  | char(1) | YES |
Olddatepnsigned |  | datetime | YES |
Newdatepnsigned |  | datetime | YES |
Oldstudentdefaultonloans |  | char(1) | YES |
Newstudentdefaultonloans |  | char(1) | YES |
OldAltBorrowerStudentLoanDebt |  | money | YES |
NewAltBorrowerStudentLoanDebt |  | money | YES |
OldborrowerInterestIndicator |  | char(1) | YES |
NewborrowerInterestIndicator |  | char(1) | YES |
OldborrowerLegalResState |  | char(2) | YES |
NewborrowerLegalResState |  | char(2) | YES |
OldborrowerLegalResStateDate |  | datetime | YES |
NewborrowerLegalResStateDate |  | datetime | YES |
OldborrowerOutstandingLoans |  | char(1) | YES |
NewborrowerOutstandingLoans |  | char(1) | YES |
OldborrowerReferenceCode |  | char(1) | YES |
NewborrowerReferenceCode |  | char(1) | YES |
OldDeferRequestCode |  | char(1) | YES |
NewDeferRequestCode |  | char(1) | YES |
OldEFTAuthorization |  | char(1) | YES |
NewEFTAuthorization |  | char(1) | YES |
OldProcessingCode |  | char(2) | YES |
NewProcessingCode |  | char(2) | YES |
OldPromNoteDeliveryCode |  | char(1) | YES |
NewPromNoteDeliveryCode |  | char(1) | YES |
OldSerialLoanCode |  | char(1) | YES |
NewSerialLoanCode |  | char(1) | YES |
OldStudentSignatureCode |  | char(1) | YES |
NewStudentSignatureCode |  | char(1) | YES |
UserId |  | int | NO |
OldCLApplicationStatus |  | char(1) | YES |
NewCLApplicationStatus |  | char(1) | YES |
DateAdded |  | datetime | NO |
OldPnSignedbyBorrower |  | char(1) | YES |
NewPnSignedbyBorrower |  | char(1) | YES |
OldDateSignedPnReceived |  | datetime | YES |
NewDateSignedPnReceived |  | datetime | YES |
OldMPNExpirationDate |  | datetime | YES |
NewMPNExpirationDate |  | datetime | YES |
OldPnDirectLoanID |  | char(21) | YES |
NewPnDirectLoanID |  | char(21) | YES |
OldDatePnPrinted |  | datetime | YES |
NewDatePnPrinted |  | datetime | YES |
OldDateDisclosurePrinted |  | datetime | YES |
NewDateDisclosurePrinted |  | datetime | YES |
OldBorrowerAlienId |  | char(9) | YES |
NewBorrowerAlienId |  | char(9) | YES |
OldBorrowerLocalZip |  | char(10) | YES |
NewBorrowerLocalZip |  | char(10) | YES |
OldUnSubEligibilityFlag |  | char(1) | YES |
NewUnSubEligibilityFlag |  | char(1) | YES |
OldUnSubEligibilityUpToHeal |  | char(1) | YES |
NewUnSubEligibilityUpToHeal |  | char(1) | YES |
OldBorrowerLocalAddress |  | varchar(2000) | YES |
NewBorrowerLocalAddress |  | varchar(2000) | YES |
OldBorrowerLocalCity |  | char(16) | YES |
NewBorrowerLocalCity |  | char(16) | YES |
OldBorrowerLocalState |  | char(2) | YES |
NewBorrowerLocalState |  | char(2) | YES |
OldLoanAmountApproved |  | money | YES |
NewLoanAmountApproved |  | money | YES |
OldOriginationFeePct |  | money | YES |
NewOriginationFeePct |  | money | YES |
OldPrintDisclosureAtLOC |  | bit | YES |
NewPrintDisclosureAtLOC |  | bit | YES |
OldStudentCitizenStatus |  | char(1) | YES |
NewStudentCitizenStatus |  | char(1) | YES |
OldStudentYearInCollege |  | char(2) | YES |
NewStudentYearInCollege |  | char(2) | YES |
Oldpnprintindicator |  | char(1) | YES |
Newpnprintindicator |  | char(1) | YES |
OldDirectLoanCOA |  | numeric(19, 4) | YES |
NewDirectLoanCOA |  | numeric(19, 4) | YES |
Oldborrowermiddlename |  | nvarchar(35) | YES |
Newborrowermiddlename |  | nvarchar(35) | YES |
Oldborrowersuffix |  | nvarchar(10) | YES |
Newborrowersuffix |  | nvarchar(10) | YES |

FaLoan_Proxy Primary and Unique Keys

Key Name | Key Type | Keys
PK_FaLoan_Proxy_FaLoan_ProxyID | PrimaryKey | FaLoan_ProxyID

FaLoan_Proxy Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
SyStaff | Non-Identifying | One To Zero or More | FK_FaLoan_Proxy_UserId_SyStaff_SyStaffId |  |  | UserId | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

FaLoan_Proxy Check Constraints

Check Constraint Name | CheckConstraint

FaLoan_Proxy Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

FaLoan_Proxy Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaLoan_Proxy | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaLoan_Proxy | NO |  |  |

FaLoan_Proxy Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaLoan_Proxy Data Movement Rules

Name | Type | Rule Text/Value